databaseName: testsp2
dataSources:
  gbasedb:
    dataSourceClassName: com.zaxxer.hikari.HikariDataSource
    jdbcUrl: jdbc:gbasedbt-sqli://192.168.0.101:23513/testsp2:GBASEDBTSERVER=gbaseserver3513;delimident=y;sqlmode=oracle;PROTOCOLTRACE=5;PROTOCOLTRACEFILE=trace2.log;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8;IFX_LOCK_MODE_WAIT=60;
    password: GBase8s
    username: gbasedbt
    connectionTestQuery: SELECT 1 FROM DUAL
    maxPoolSize: 10
rules:
  - !SHARDING
    tables:
      t_user:
        actualDataNodes: gbasedb.b_useR_${0..1}
        tableStrategy:
          standard:
            shardingColumn: id
            shardingAlgorithmName: table_inline
    shardingAlgorithms:
      table_inline:
          type: INLINE
          props:
            algorithm-expression: b_useR_${id % 2}
  - !SINGLE
    tables:
      - "gbasedb.*"
props:
  sql-show: true